package org.lanqiao.userprofile.movie.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.lanqiao.userprofile.movie.entity.OdsMovieInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author root
 * @since 2023-09-25
 */
@Mapper
public interface OdsMovieInfoDao extends BaseMapper<OdsMovieInfo> {

    @Select("select * from ods_movie_info where score is not null and score <>'null' order by score desc limit 5")
    List<OdsMovieInfo> queryTop();
}
